acc219c12bbd165de3bf9a1aae87cb6aa87a1dc2,src/main/java/db/DbManager.java,DbManager,getFieldValue,#String#String#String#String#,36

Before Change


        String query = "SELECT " + field + " FROM " + table + " WHERE " + keyName + "=?";
        try
        {
            PreparedStatement statement = connection.prepareStatement(query);
            statement.setString(1, keyValue);
            ResultSet resultSet = statement.executeQuery();
            if (resultSet.next())
            {
                fieldValue = resultSet.getString(1);
            }
            resultSet.close();
            statement.close();
        }
        catch (SQLException e)

After Change


        ResultSet resultSet = null;
        try
        {
            statement = connection.prepareStatement(query);
            statement.setString(1, keyValue);
            resultSet = statement.executeQuery();
            if (resultSet.next())
            {
                fieldValue = resultSet.getString(1);